package pers.lmd.mapper;

import org.apache.ibatis.annotations.Select;
import pers.lmd.domain.vo.AssistVO;
import pers.lmd.domain.entity.Assist;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.util.List;

/**
* @author 10149
* @description 针对表【assist】的数据库操作Mapper
* @createDate 2023-05-02 22:13:12
* @Entity pers.lmd.domain.entity.Assist
*/
public interface AssistMapper extends BaseMapper<Assist> {
    @Select("SELECT student.phone,student.email,assist.description FROM student,assist where assist.sid = student.id")
    List<AssistVO> getAssist();
}




